Search Results
SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND FROM_DAYS(TO_DAYS(NOW()) - 1825) <= `ModifiedDate` AND FROM_DAYS(TO_DAYS(NOW()) - 1460) >= `ModifiedDate` AND `Language` = 'English' AND `IsPrimary` = 1 ORDER BY `LinkText`, `Item`.`Summary` ASC LIMIT 500 OFFSET 0
Opulent Chess. A derivative of Grand Chess with additional jumping pieces (Lion and Wizard). (10x10, Cells: 100)